﻿/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-29 17:56:01
*/


-- ----------------------------
-- Table structure for tb0081
-- ----------------------------
DROP TABLE [dbo].[tb0081]
GO
CREATE TABLE [dbo].[tb0081] (
[AssetGroupID] varchar(20) NOT NULL ,
[AssetGroupName] nvarchar(150) NULL ,
[Disabled] tinyint NOT NULL DEFAULT((0)),
[CreateDate] datetime NULL ,
[CreateUserID] varchar(20) NULL ,
[LastModifyDate] datetime NULL ,
[LastModifyUserID] varchar(20) NULL ,
[Orders] tinyint NULL 
)

GO

-- ----------------------------
-- Records of tb0081
-- ----------------------------
INSERT INTO [dbo].[tb0081] ([AssetGroupID], [AssetGroupName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Orders]) VALUES (N'MM', N'MÁY MÓC', N'0', N'2012-07-28 12:01:40.197', N'ADMIN', N'2012-07-28 12:01:40.197', N'ADMIN', N'1')
GO
GO
INSERT INTO [dbo].[tb0081] ([AssetGroupID], [AssetGroupName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Orders]) VALUES (N'NC', N'NHÀ CỬA, VẬT KIẾN TRÚC', N'0', N'2012-07-28 12:02:11.647', N'ADMIN', N'2012-07-28 12:02:11.647', N'ADMIN', N'2')
GO
GO
INSERT INTO [dbo].[tb0081] ([AssetGroupID], [AssetGroupName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [Orders]) VALUES (N'PTVT', N'PHƯƠNG TIỆN VẬN TẢI', N'0', N'2012-07-28 12:02:32.210', N'ADMIN', N'2012-07-28 12:02:32.210', N'ADMIN', N'3')
GO
GO

-- ----------------------------
-- Indexes structure for table tb0081
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb0081
-- ----------------------------
ALTER TABLE [dbo].[tb0081] ADD PRIMARY KEY NONCLUSTERED ([AssetGroupID])
GO
